UCSF

Parameters Provided:

name.synonym = 7H3SF; AC-Di-sol. NF; Aku-W 515; Aquaplast; Avicel RC/CL; B 10; B 10 (Polysaccharide); Blanose BS 190; Blanose BWM; CCRIS 3653; CM-Cellulose sodium salt; CMC; CMC 2; CMC 3M5T; CMC 41A; CMC 4H1; CMC 4M6; CMC 7H; CMC 7H3SF; CMC 7L1; CMC 7M; CMC 7MT; CMC sod
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '7H3SF; AC-Di-sol. NF; Aku-W 515; Aquaplast; Avicel RC/CL; B 10; B 10 (Polysaccharide); Blanose BS 190; Blanose BWM; CCRIS 3653; CM-Cellulose sodium salt; CMC; CMC 2; CMC 3M5T; CMC 41A; CMC 4H1; CMC 4M6; CMC 7H; CMC 7H3SF; CMC 7L1; CMC 7M; CMC 7MT; CMC sod' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=7H3SF%3B+AC-Di-sol.+NF%3B+Aku-W+515%3B+Aquaplast%3B+Avicel+RC%2FCL%3B+B+10%3B+B+10+%28Polysaccharide%29%3B+Blanose+BS+190%3B+Blanose+BWM%3B+CCRIS+3653%3B+CM-Cellulose+sodium+salt%3B+CMC%3B+CMC+2%3B+CMC+3M5T%3B+CMC+41A%3B+CMC+4H1%3B+CMC+4M6%3B+CMC+7H%3B+CMC+7H3SF%3B+CMC+7L1%3B+CMC+7M%3B+CMC+7MT%3B+CMC+sod&filter.purchasability=all

Embed Link to Results